NTISthis.com

Evidence Guide: ICTDBS415 - Build a database

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICTDBS415 - Build a database

What evidence can you provide to prove your understanding of each of the following citeria?

Confirm the database design

  1. Review database design documentation, including data structures, queries, reports, and user interfaces to identify organisational data management, access and security requirements
  2. Evaluate sufficiency of database access and security feature design to organisational data security plan
  3. Document and rectify inconsistencies between database design and organisational data security plan
Review database design documentation, including data structures, queries, reports, and user interfaces to identify organisational data management, access and security requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Evaluate sufficiency of database access and security feature design to organisational data security plan

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Document and rectify inconsistencies between database design and organisational data security plan

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create a prototype database

  1. Develop prototype database according to database design
  2. Populate database tables with current organisational data to test database implementation
  3. Write conversion programs to import data from existing systems in accordance with scope specified in database design documentation
  4. Assess functionality of prototype with user, including identifying errors in program code and modifying user interfaces and reports
  5. Incorporate feedback from user into prototype
  6. Obtain user approval of prototype
Develop prototype database according to database design

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Populate database tables with current organisational data to test database implementation

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Write conversion programs to import data from existing systems in accordance with scope specified in database design documentation

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assess functionality of prototype with user, including identifying errors in program code and modifying user interfaces and reports

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Incorporate feedback from user into prototype

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Obtain user approval of prototype

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Deploy the database

  1. Develop implementation plan for database aligned with user acceptance criteria
  2. Install database management system software on network in accordance with implementation plan
  3. Populate database tables with organisational data in accordance with implementation plan
  4. Implement security and access controls in accordance with database design documentation and implementation plan
  5. Test and document database output and security controls, and record results in accordance with database design documentation
Develop implementation plan for database aligned with user acceptance criteria

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Install database management system software on network in accordance with implementation plan

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Populate database tables with organisational data in accordance with implementation plan

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Implement security and access controls in accordance with database design documentation and implementation plan

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test and document database output and security controls, and record results in accordance with database design documentation

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Evaluate the database

  1. Review the database against user acceptance criteria and rectify discrepancies
  2. Complete database documentation in accordance with user acceptance criteria
  3. Identify and document user training requirements from database design documentation
  4. Seek and secure user acceptance of database in accordance with user acceptance criteria
Review the database against user acceptance criteria and rectify discrepancies

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Complete database documentation in accordance with user acceptance criteria

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Identify and document user training requirements from database design documentation

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Seek and secure user acceptance of database in accordance with user acceptance criteria

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Required Skills and Knowledge